﻿using System;
using System.Data;
using WP.Commons;

namespace WP.RM.DataEntity
{
    //=========MCity  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class RMProductDEL : DataSet, IDataEntity
    {
        //=========mCity ============================
        public const string TABLENAME_RMProduct = "rmProduct";

        public const string RECID = "RecId";
        public const string CategoryID = "CategoryID";
        public const string CategoryName = "CategoryName";
        public const string SetID = "SetID";
        public const string SetName = "SetName";

        public const string ProductID = "ProductID";
        public const string ProductFItemID = "ProductFItemID";
        public const string ProductName = "ProductName";
        public const string RECSTAMP = "RecStamp";
        public const string Pages = "Pages";
        public const string Remark = "Remark";

        public const string Quantity = "Quantity";
        public const string Ver = "Ver";
        public const string KDCode = "KDCode";
        public const string ProductType = "ProductType";

        public const string BaseSetSize="BaseSetSize";
        public const string BaseProductLength = "BaseProductLength";
        public const string BaseProductWidth = "BaseProductWidth";
        public const string BaseMaterialLength = "BaseMaterialLength";
        public const string BaseMaterialWidth = "BaseMaterialWidth";
        public const string BaseMaterialWeight = "BaseMaterialWeight";

        public const string InnerCirclePaperWidth = "InnerCirclePaperWidth";
        public const string InnerWeight = "InnerWeight";
        public const string InnerHeight = "InnerHeight";
        public const string InnerSetSize = "InnerSetSize";
        public const string InnerPages = "InnerPages";
        public const string InnerCutFactor = "InnerCutFactor";
        public const string InnerJoinWidth = "InnerJoinWidth";
        public const string InnerProdLength = "InnerProdLength";
        public const string InnerProdWidth = "InnerProdWidth";
        public const string InnerCutSize = "InnerCutSize";
        public const string InnerJoinLength = "InnerJoinLength";

        public const string FrontCoverHeight = "FrontCoverHeight";
        public const string BackCoverHeight = "BackCoverHeight";
        public const string FrontCoverSize = "FrontCoverSize";
        public const string BackCoverSize = "BackCoverSize";
        public const string BackMateriallFactor = "BackMateriallFactor";
        public const string BackPSFactor = "BackPSFactor";
        public const string PagePrintLength = "PagePrintLength";
        public const string PagePrintWidth = "PagePrintWidth";
        public const string CoverJoinLength = "CoverJoinLength";
        public const string CoverJoinWidth = "CoverJoinWidth";
        public const string CoverMaterialLength = "CoverMaterialLength";
        public const string CoverMaterialWidth = "CoverMaterialWidth";
        public const string BackPSQty1 = "BackPSQty1";
        public const string BackPSQty2 = "BackPSQty2";
        public const string BackPSQty3 = "BackPSQty3";
        public const string BackPSQty4 = "BackPSQty4";
        public const string BackPrintInnerQty = "BackPrintInnerQty";
        public const string OthersBackPaperQty = "OthersBackPaperQty";
        
        public const string OthersBackQty = "OthersBackQty";
        
        public const string BackPrintInnerQty2 = "BackPrintInnerQty2";
        public const string BackCutFactor1 = "BackCutFactor1";
        public const string BackCutFactor2 = "BackCutFactor2";

        public const string LaminatingLength = "LaminatingLength";
        public const string LaminatingWidth = "LaminatingWidth";

        public const string HCWeight = "HCWeight";
        public const string HCSetSize = "HCSetSize";
        public const string HCHeight = "HCHeight";
        public const string HCPages = "HCPages";

        public const string StEDPageWeigth = "StEDPageWeigth";
        public const string StEDPageSetSize = "StEDPageSetSize";
        public const string StEDPageHeight = "StEDPageHeight";
        public const string StEDPagePages = "StEDPagePages";
        public const string StEDPageCirclePaperWidth = "StEDPageCirclePaperWidth";
        public const string PKGContainQty = "PKGContainQty";
        public const string PKGPackageQty = "PKGPackageQty";
        public const string PKGInnerDiameterLength = "PKGInnerDiameterLength";
        public const string PKGInnerDiameterWidth = "PKGInnerDiameterWidth";
        public const string PKGInnerDiameterHeight = "PKGInnerDiameterHeight";
        public const string PKGRows = "PKGRows";
        public const string PKGQty = "PKGQty";

        public const string OthersLockingWireQty = "OthersLockingWireQty";
        public const string OthersLockingWireLength = "OthersLockingWireLength";
        public const string OthersBackWidth = "OthersBackWidth";
        public const string OthersUseIronNailQty = "OthersUseIronNailQty";
        public const string OthersMiddleWidth = "OthersMiddleWidth";
        public const string OthersSheetSize = "OthersSheetSize";
        public const string OthersBurrWidth = "OthersBurrWidth";
        public const string OthersWireLength = "OthersWireLength";
        public const string OthersMiddleSize = "OthersMiddleSize";
        public const string OthersSheetLength = "OthersSheetLength";
        public const string OthersSheetWidth = "OthersSheetWidth";
        public const string OthersOneSheetLength = "OthersOneSheetLength";

        public const string OthersCopyPaperPS1 = "OthersCopyPaperPS1";
        public const string OthersCopyPaperPS2 = "OthersCopyPaperPS2";

        public const string PKGInQty="PKGInQty";
                            public const string PKGInLength="PKGInLength";
                            public const string PKGInWidth="PKGInWidth";
                            public const string PKGInHeight="PKGInHeight";
                            public const string HCJoinLength="HCJoinLength";
                            public const string HCJoinWidth="HCJoinWidth";
                            public const string HCSingleLength="HCSingleLength";
                            public const string HCSingleWidth="HCSingleWidth";

                            public const string StEDPageJoinLength="StEDPageJoinLength";
                            public const string StEDPageJoinWidth="StEDPageJoinWidth";
                            public const string StEDPageSplitSize="StEDPageSplitSize";
                            public const string OthersLineQty = "OthersLineQty";

        public const string  HCSplitWeight="HCSplitWeight";
         public const string HCSplitSet="HCSplitSet";
         public const string HCSplitHeight="HCSplitHeight";
         public const string HCSplitQty = "HCSplitQty";

        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public RMProductDEL()
        {
            //Create mCity structure
            CreatemCityStructure();
        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_RMProduct);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(ProductFItemID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(Pages, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductID, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductName, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(Remark, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CategoryID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);


            DC = new DataColumn(CategoryName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(KDCode, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(Ver, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(Quantity, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductType, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(BaseSetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(BaseProductLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BaseProductWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BaseMaterialLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BaseMaterialWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BaseMaterialWeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(InnerCirclePaperWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerWeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerSetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerPages, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerCutFactor, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerJoinWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerProdLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerProdWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerCutSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerJoinLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FrontCoverHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackCoverHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FrontCoverSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackCoverSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackMateriallFactor, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPSFactor, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PagePrintLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PagePrintWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CoverJoinLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CoverJoinWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CoverMaterialLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CoverMaterialWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPSQty1, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPSQty2, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPSQty3, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPSQty4, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPrintInnerQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersBackPaperQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersBackQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackPrintInnerQty2, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackCutFactor1, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BackCutFactor2, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LaminatingLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LaminatingWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCWeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCPages, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageWeigth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageSetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPagePages, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGContainQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGPackageQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGInnerDiameterLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGInnerDiameterWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGInnerDiameterHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageCirclePaperWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(PKGRows, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersLockingWireQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersLockingWireLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersBackWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersUseIronNailQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersMiddleWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersSheetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersBurrWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersWireLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersMiddleSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersSheetLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersSheetWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersOneSheetLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersCopyPaperPS1, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OthersCopyPaperPS2, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);



            DC = new DataColumn(PKGInQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PKGInLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(PKGInWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(PKGInHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);




            DC = new DataColumn(HCJoinLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCJoinWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSingleLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSingleWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(StEDPageJoinLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageJoinWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(StEDPageSplitSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(OthersLineQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSplitWeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSplitSet, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSplitHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(HCSplitQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            this.Tables.Add(table);
        }


    }
}
